This appendix contains sample reports.
Date 05/25/2019 Time 10:25:17 XYZ Company Report #0125 Page 0001
L A B E L L A Y O U T E D I T L I S T
“COD” label layouts
------------------------------------------------------------------------------------------------------------------------------------
#-lines #-cols #-labels Beg-col Beg-col Beg-col Beg-col
per-label per-label across-page 1st-label 2nd-label 3rd-label 4th-label
------------------------------------------------------------------------------------------------------------------------------------
Label # 1 COD Label Type: COD
====================================================
7 55 1 1
Fld-# Description Row Col Length Type Format
6 Ship-to name 1 1 25 Alpha Justify left
10 Shipping date 1 35 8 Date 09/30/19
7 Ship-to address line 1 2 1 25 Alpha Justify left
8 Ship-to address line 2 3 1 31 Alpha Justify left
9 Ship-to address line 3 4 1 31 Alpha Justify left
** TEXT ** 6 1 10 Text Invoice #:
13 Invoice number 6 13 6 Num 999999
** TEXT ** 6 26 11 Text COD Amount:
34 COD dollar amount 6 40 14 Num 999,999,999.99
Date 05/25/2019 Time 10:25:17 XYZ Company Report #0125 Page 0002
L A B E L L A Y O U T E D I T L I S T
------------------------------------------------------------------------------------------------------------------------------------
#-lines #-cols #-labels Beg-col Beg-col Beg-col Beg-col
per-label per-label across-page 1st-label 2nd-label 3rd-label 4th-label
------------------------------------------------------------------------------------------------------------------------------------
Label # 5 Label Test #1 Type: COD
====================================================
21 33 4 1 34 67 100
Fld-# Description Row Col Length Type Format
** TEXT ** 1 1 17 Text Sample label text
32 System date 4 4 8 Date 09/30/19
1 Company name 10 5 25 Alpha Justify left
34 COD dollar amount 12 8 14 Num 999,999,999.99
-- End of report --
Date 05/25/2019 Time 11:27:11 XYZ Company Report #0126 Page 0001
F O R M S L I S T
Form ID range: “First” to “Last”
Type: “All”
Print format: Z = no leading zeros, F = floating decimal, “*field name” = not valid for handles selection
------------------------------------------------------------------------------------------------------------------------------------
Form Type Description Paginated Width Handles Length 1st Hdrs 1st Last 1st
ID Line 1st Line Line Line
Hdrs Pag? Item Item Totals
------------------------------------------------------------------------------------------------------------------------------------
1 Credit memo 6.x-LRFS57 Form Y 80 Items and Services 66 1 N 26 55 59
1 Invoice 6.x-LRFS57 Form Y 80 Items and Services 66 1 N 26 55 59
1 Loan 6.x-LRFS57 Form Y 80 Items and Services 66 1 N 26 55 59
1 Order 6.x-LRFS57 Form Y 80 Items and Services 66 1 N 26 55 59
1 Quote 6.x-LRFS57 Form Y 80 Items and Services 66 1 N 26 55 59
1 RMA 6.x-LRFS57 Form Y 80 Items and Services 66 1 N 26 55 59
1 Rental 6.x-LRFS57 Form Y 80 Items and Services 66 1 N 26 55 59
10 Credit memo 6.x-LRFS59 Form Y 80 Items and Services 66 1 N 22 55 57
10 Invoice 6.x-LRFS59 Form Y 80 Items and Services 66 1 N 22 55 57
10 Loan 6.x-LRFS59 Form Y 80 Items and Services 66 1 N 22 55 57
10 Order 6.x-LRFS59 Form Y 80 Items and Services 66 1 N 22 55 57
10 Quote 6.x-LRFS59 Form Y 80 Items and Services 66 1 N 22 55 57
10 RMA 6.x-LRFS59 Form Y 80 Items and Services 66 1 N 22 55 57
10 Rental 6.x-LRFS59 Form Y 80 Items and Services 66 1 N 22 55 57
20 Credit memo 6.x-LRFS56 Form Y 80 Items and Services 66 1 N 26 57 59
20 Invoice 6.x-LRFS56 Form Y 80 Items and Services 66 1 N 26 57 59
20 Loan 6.x-LRFS56 Form Y 80 Items and Services 66 1 N 26 57 59
20 Order 6.x-LRFS56 Form Y 80 Items and Services 66 1 N 26 57 59
20 Quote 6.x-LRFS56 Form Y 80 Items and Services 66 1 N 26 57 59
20 RMA 6.x-LRFS56 Form Y 80 Items and Services 66 1 N 26 57 59
20 Rental 6.x-LRFS56 Form Y 80 Items and Services 66 1 N 26 57 59
30 Credit memo Picking Ticket Y 80 Items and Services 66 1 N 24 56 58
30 Invoice Picking Ticket Y 80 Items and Services 66 1 N 24 56 58
30 Loan Picking Ticket Y 80 Items and Services 66 1 N 24 56 58
30 Order Picking Ticket Y 80 Items and Services 66 1 N 24 56 58
30 Quote Picking Ticket Y 80 Items and Services 66 1 N 24 56 58
30 RMA Picking Ticket Y 80 Items and Services 66 1 N 24 56 58
30 Rental Picking Ticket Y 80 Items and Services 66 1 N 24 56 58
40 Order Sample form Y 90 Items and Services 66 1 N 3 55 58
29 forms on file
-- End of report --
Date 05/25/2019 Time 11:27:47 XYZ Company Report #0127 Page 0001
F O R M S L I S T
Form ID range: 1 to 1
Type: Order
Print format: Z = no leading zeros, F = floating decimal, “*field name” = not valid for handles selection
------------------------------------------------------------------------------------------------------------------------------------
Form Type Description Paginated Width Handles Length 1st Hdrs 1st Last 1st
ID Line 1st Line Line Line
Hdrs Pag? Item Item Totals
------------------------------------------------------------------------------------------------------------------------------------
1 Order 6.x-LRFS57 Form Y 80 Items and Services 66 1 N 26 55 59
------------------------------------------------------------------------------------------------------------------------------------
Field group Line Column Field Print when Cond Value Print format
------------------------------------------------------------------------------------------------------------------------------------
Headers 4 10 Company report name Len: 25
5 10 Company address 1 Len: 30
6 10 Company address 2 Len: 30
7 10 Company address 3 Len: 30
58 Invoice date 05/25/19
69 Invoice number ZZZZZZ
77 Page number ZZZ
11 31 Literal “*** Order *** “
14 7 Bill-to name Len: 25
47 Ship-to name Len: 25
15 7 Bill-to address 1 Len: 25
47 Ship-to address 1 Len: 25
16 7 Bill-to address 2 Len: 31
47 Ship-to address 2 Len: 31
17 7 Bill-to address 3 Len: 31
47 Ship-to address 3 Len: 31
22 1 Order number ZZZZZZ
9 Order date 05/25/19
18 Cust number Len: 12
32 Sales rep Len: 3
37 PO number Len: 15
54 Ship date 05/25/19
65 Ship-via description Len: 15
Line items 1 2 Qty ordered ZZZZZ9.999-
15 Item stocking unit Len: 4
21 Item/Svc number Len: 11
34 Description 1 Len: 23
60 Item/Svc prcng unit Len: 4
68 Unit price ZZZZZZ9.99-
2 2 Qty to ship ZZZZZ9.999-
21 Qty backord ZZZZZZZ9.999-
34 Description 2 Len: 23
60 Discount percent Z9.99-
67 Net extended price ZZZZZZZ9.99-
Totals 1 64 Sale amount ZZZZZZ9.99-
2 64 Misc amount ZZZZZZ9.99-
3 64 Freight amount ZZZZZZ9.99-
4 64 Tax total amount ZZZZZZ9.99-
5 64 Order net total amt ZZZZZZ9.99-
Date 05/25/2019 Time 11:27:47 XYZ Company Report #0127 Page 0002
F O R M S L I S T
------------------------------------------------------------------------------------------------------------------------------------
Field group Line Column Field Print when Cond Value Print format
------------------------------------------------------------------------------------------------------------------------------------
6 64 Cash amount rcvd ZZZZZZ9.99-
7 64 Balance due ZZZZZZ9.99-
41 fields defined
1 form printed
-- End of report --
Date 05/25/2019 Time 15:29:57 XYZ Company Report #0128 Page 0001
O R D E R E D I T L I S T
OVERRIDE next to “Commission” means that commission depended on gross profit but was overridden.
Ord-#: 1 Date: 05/25/19 Cust-#1 Elliot Enterprises Ship-to Elliot Enterprises
Type: Order 123 Broadway 123 Broadway
Sub acct: 100 Suite 500 Suite 500
Warehouse: All Glendale, CA 94994 Glendale, CA 94994
Country: USA Country: USA
---Cust-PO#---- ---Ship-via---- Ship-date -----Terms----- Ord-disc% --------Tax codes-------- --------Sales rep-------- Status
Truck 05/25/19 Cash 0.000 Taxable Sales L.A. City Thomas J. Finch
------------------------------------------------------------------------------------------------------------------------------------
Seq-# Qty-ordered Unit Qty-to-ship Item/Svc # Unit price Extend-price Shp-date Whse
Type Qty-backord Description-1 Line disc% Scrap/Sls-acct
Description-2
------------------------------------------------------------------------------------------------------------------------------------
10 1 EACH 1 1 49.00 EACH 49.00 5/25/19 1
Goods Drill, 1/4” Power Hand
1 line
Total weight: 3.00
Ordr total: 49.00 Misc amt: 0.00
Ship total: 49.00 Freight: 0.00
Txbl total: 49.00 Tax amt: 0.00
Discnt net: 49.00 Tot sale: 49.00
Amt recd: 0.00
Bal due: 49.00
Tax rate-1 0.00
Date 05/25/2019 Time 15:29:57 XYZ Company Report #0128 Page 0002
O R D E R E D I T L I S T
Ord-#: 2 Date: 05/25/19 Cust-#10 Harris, Goldberg & Jones Ship-to Harris, Goldberg & Jones
Type: Invoice 456 W. 7th Street 456 W. 7th Street
Sub acct: 100 Suite 100 Suite 100
Warehouse: All San Diego, CA 92100 San Diego, CA 92100
Country: USA Country: USA
---Cust-PO#---- ---Ship-via---- Ship-date -----Terms----- Ord-disc% --------Tax codes-------- --------Sales rep-------- Status
Parcel Post 05/25/19 Normal Terms 0.000 District tax code Thomas J. Finch SELECTED
------------------------------------------------------------------------------------------------------------------------------------
Seq-# Qty-ordered Unit Qty-to-ship Item/Svc # Unit price Extend-price Shp-date Whse
Type Qty-backord Description-1 Line disc% Scrap/Sls-acct
Description-2
------------------------------------------------------------------------------------------------------------------------------------
10 4 EACH 4 4 56.00 EACH 224.00 5/25/19 1
Goods Saw, 2hp 7 1/4” Circular
-------------------------Serial-Information--------------------------
Serial-# Reference Warranty
100 EXTEND Extended Warranty
102 thru 104 EXTEND Extended Warranty
---------------------------------------------------------------------
1 line
Ordr total: 224.00 Misc amt: 0.00
Ship total: 224.00 Freight: 0.00
Txbl total: 224.00 Tax amt: 13.49
Discnt net: 224.00 Tot sale: 237.49
Amt recd: 0.00
Bal due: 237.49
Tax rate-1 6.57 Tax rate-2 6.92
Date 05/25/2019 Time 15:29:57 XYZ Company Report #0128 Page 0003
O R D E R E D I T L I S T
Ord-#: 3 Date: 05/25/19 Cust-#1 Elliot Enterprises Ship-to Elliot Enterprises
Type: CR Memo Apply-to: 1018 123 Broadway 123 Broadway
Sub acct: 000 Suite 500 Suite 500
Warehouse: All Glendale, CA 94994 Glendale, CA 94994
Country: Country:
---Cust-PO#---- ---Ship-via---- Ship-date -----Terms----- Ord-disc% --------Tax codes-------- --------Sales rep-------- Status
Truck N/A Cash 0.000 Taxable Sales L.A. City Thomas J. Finch SELECTED
------------------------------------------------------------------------------------------------------------------------------------
Seq-# Qty-creditd Unit Qty-returnd Item/Svc # Unit price Extend-price Shp-date Whse
Type Description-1 Line disc% Scrap/Sls-acct
Description-2
------------------------------------------------------------------------------------------------------------------------------------
10 1 EACH 1 1 49.00 EACH 49.00CR N/A Central
Goods Drill, 1/4” Power Hand
20 2 EACH 2 3 23.50 EACH 47.00CR N/A Central
Goods Wrench, 3/8” Socket Set 7030-000
2 lines
Total weight: 3.00
Ordr total: 96.00CR Misc amt: 0.00
Ship total: 96.00CR Freight: 0.00
Txbl total: 96.00CR Tax amt: 6.72CR
Discnt net: 96.00CR Tot sale: 102.72CR
Tax rate-1 6.72
Date 05/25/2019 Time 15:29:57 XYZ Company Report #0128 Page 0004
O R D E R E D I T L I S T
S U M M A R Y
Order # range: “First” to “Last”
Order date range: “Earliest” to “Latest”
Warehouse: All
Order totals: 1 Orders 1 Line items Sale amt: 49.00
Misc chg: 0.00
Tax amt: 0.00
Freight: 0.00
Total: 49.00
Amt recd: 0.00
Bal due: 49.00
Invoice totals: 1 Invoices 1 Line items Sale amt: 224.00
Misc chg: 0.00
Tax amt: 13.49
Freight: 0.00
Total: 237.49
Amt recd: 0.00
Bal due: 237.49
Cr memo totals: 1 CR memos 2 Line items Sale amt: 96.00CR
Misc chg: 0.00
Tax amt: 6.72CR
Freight: 0.00
Total: 102.72CR
Grand totals: 3 Documents 4 Line items Sale amt: 177.00
Misc chg: 0.00
Tax amt: 6.77
Freight: 0.00
Total: 183.77
Amt recd: 0.00
Bal due: 183.77
-- End of report --
Date 05/25/2019 Time 15:37:09 XYZ Company Report #0130 Page 0001
E . D . I . I M P O R T R E P O R T
------------------------------------------------------------------------------------------------------------------------------------
O/E order # E.D.I. document # Number of order lines Pages of order notes Messages
------------------------------------------------------------------------------------------------------------------------------------
Total orders processed: 1 Total orders in error: 1 Total orders imported: 0
-- End of report --
Date 05/26/2019 Time 10:46:00 XYZ Company Report #0131 Page 0001
R E C U R R I N G O R D E R S L I S T
Next date cut-off: “Latest”
The costs shown on this list are the current value of the replacement costs.
OVERRIDE next to “Commission” means that commission depended on gross profit but was overridden.
Costs and Margins are approximate.
Ref-#: 974B (Not sel) Cust: 40 Washington, Mrs. Thomas Ship-to Washington, Mrs. Thomas
Type: Order 350 Hillcrest Circle 350 Hillcrest Circle
Group: Dallas, TX 75201 Dallas, TX 75201
Sub acct: 100
Warehouse: All
---Cust-PO#---- ---Ship-via---- Ship-date -----Terms----- Ord-disc% --------Tax codes-------- --------Sales rep-------- Status
974B Parcel Post ASAP Net 30 0.000 Out of State Sales Tax Thomas J. Finch
------------------------------------------------------------------------------------------------------------------------------------
Seq-# Qty-ordered Unit Total-qty Item/Svc # Unit price Extend-price Ship date
Qty-remain Description-1 Line disc% Unit cost B/O-instr
Description-2
------------------------------------------------------------------------------------------------------------------------------------
10 3 EACH INDEFINITE 3 23.50 EACH 70.50 ASAP
N/A Wrench, 3/8” Socket Set 8.50 N/A
1 line
Commission: 0.00
Ordr total: 70.50 Misc amt: 0.00
Txbl total: 70.50 Freight: 0.00
Discnt net: 70.50 Tax amt: 0.00
Apprx cost: 25.50 Tot sale: 70.50
Apprx mrgn: 45.00
Recurrence information: Interval: every 1 month Already billed: 0.00 Previous order #: NONE YET
Next date: 5/25/19 Max # of times: INDEFINITE Previous invoice #: NONE YET
Start date: 5/25/19 Times so far: 0 Previous invc date:
Final date: INDEFINITE
Date 05/26/2019 Time 10:46:00 XYZ Company Report #0131 Page 0002
R E C U R R I N G O R D E R S L I S T
Ref-#: 948H (Not sel) Cust: 50 Space Concepts & Design Ship-to Space Concepts & Design
Type: Invoice 3901 Ave. of the Americas 3901 Ave. of the Americas
Group: Suite 360 Suite 360
Sub acct: 100 New York, NY 10052 New York, NY 10052
Warehouse: All
---Cust-PO#---- ---Ship-via---- Ship-date -----Terms----- Ord-disc% --------Tax codes-------- --------Sales rep-------- Status
948H Parcel Post NONE YET 5/10 net 25 0.000 Out of State Sales Tax Avram Goldberger
------------------------------------------------------------------------------------------------------------------------------------
Seq-# Qty-ordered Unit Total-qty Item/Svc # Unit price Extend-price Ship date
Qty-remain Description-1 Line disc% Unit cost B/O-instr
Description-2
------------------------------------------------------------------------------------------------------------------------------------
10 0 EACH 1 5 17.59 EACH 0.00 NONE YET
1 Chisel, 5 pc Set 5.00 Override
1 line
Commission: 0.00
Ordr total: 0.00 Misc amt: 8.00 Dist-to: 4040-000
Txbl total: 0.00 Freight: 4.00 Dist-to: 4030-300
Discnt net: 0.00 Tax amt: 0.00
Apprx cost: 0.00 Tot sale: 12.00
Apprx mrgn: 0.00
Recurrence information: Interval: every 1 week Already billed: 0.00 Previous order #: NONE YET
Next date: 5/25/19 Max # of times: INDEFINITE Previous invoice #: NONE YET
Start date: 5/25/19 Times so far: 0 Previous invc date:
Final date: INDEFINITE
-- End of report --
Recurring Orders Exception Report
Date 05/26/2019 Time 11:04:05 XYZ Company Report #0132 Page 0001
R E C U R R I N G O R D E R S E X C E P T I O N R E P O R T
“*” after qty-ordered indicates item is drop shipped.
------------------------------------------------------------------------------------------------------------------------------------
Cust-# Name Ref-# Order-# Type Order-date Ship-date
------------------------------------------------------------------------------------------------------------------------------------
50 Space Concepts & Design 948H 4 Invoice 5/26/19 5/26/19
Seq-# Qty-ordered Unit Qty-remaining Item-number Description Unit-price Extend-price Ship-date
10 0 EACH 1 5 Chisel, 5 pc Set 17.59 0.00 5/26/19
Qty-ordered is zero - line item not created.
-- End of report --
Date 05/26/2019 Time 12:27:22 XYZ Company Report #0133 Page 0001
B A C K O R D E R S B Y C U S T O M E R
For all customers
------------------------------------------------------------------------------------------------------------------------------------
Customer-# Item number Cust-PO# Ordr-# Ord-date Qty-BO Unit Unit-price
Customer-name Description-1 Shp-date Disc-% Whse Ext-price
Description-2
------------------------------------------------------------------------------------------------------------------------------------
40 2 5 5/26/19 182 EACH 26.50 EACH
Washington, Mrs. Thomas Hammer, 16 oz. Claw 5/26/19 0.000 Cen 4,823.00
B/O’s for customer 40 1 orders with extended price of 4,823.00
Grand total extended price of backordered items: 4,823.00
-- End of report --
Date 05/26/2019 Time 12:29:58 XYZ Company Report #0134 Page 0001
B A C K O R D E R S B Y I T E M
For all items
Warehouse: “All”
------------------------------------------------------------------------------------------------------------------------------------
Item-number Customer-# Customer-name Ordr-# Ord-date Qty-BO Unit Unit-price
Description-1 Customer-PO# Shp-date Disc-% Whse Ext-price
Description-2
------------------------------------------------------------------------------------------------------------------------------------
2 40 Washington, Mrs. Thomas 5 5/26/19 182 EACH 26.50 EACH
Hammer, 16 oz. Claw 5/26/19 0.000 Central 4,823.00
B/O’s for item 2 1 orders with total quantity of 182 EACH and extended price of 4,823.00
Grand total extended price of backordered items: 4,823.00
-- End of report --
Date 05/26/2019 Time 12:48:32 XYZ Company Report #0135 Page 0001
F I L L B A C K O R D E R S E D I T L I S T
Order range: “First” to “Last” D E T A I L B Y I T E M #
Customer range: “First” to “Last”
Item range: “First” to “Last”
Warehouse: “All”
“P/F” indicates a line partially filled
“P/N” indicates a line which could be partially filled, but customer doesn’t accept partial shipments
------------------------------------------------------------------------------------------------------------------------------------
Cust-# Cust-name Ordr-# Cust-PO-# Ord-date Shp-date Qty-backord Qty-filled Ext-price
------------------------------------------------------------------------------------------------------------------------------------
Item-#: 2 Description: Hammer, 16 oz. Claw Warehouse: Central
40 Washington, Mrs. Thomas 5 5/26/19 5/26/19 182 0 0.00
*** Warehouse out of stock, but qty available at another warehouse ***
Totals for item 2 Warehouse Central 0 Lines filled 0 0 0.00
1 Lines not filled 182 remain on BO 4823.00
Grand totals: 0 Lines filled 0 0 0.00
1 Lines not filled 182 remain on BO 4823.00
-- End of report --
Date 05/26/2019 Time 17:06:16 XYZ Company Report #0136 Page 0001
B I L L I N G E D I T L I S T
OVERRIDE next to “Commission” means that commission depended on gross profit but was overridden.
Ord-#: 6 Date: 05/26/19 Cust-#40 Washington, Mrs. Thomas Ship-to Washington, Mrs. Thomas
Type: Order 350 Hillcrest Circle 350 Hillcrest Circle
Sub acct: 100 Dallas, TX 75201 Dallas, TX 75201
Warehouse: All
Country: USA Country: USA
---Cust-PO#---- ---Ship-via---- Ship-date -----Terms----- Ord-disc% --------Tax codes-------- --------Sales rep-------- Status
Parcel Post 05/26/19 Net 30 0.000 Out of State Sales Tax Thomas J. Finch SELECTED
------------------------------------------------------------------------------------------------------------------------------------
Seq-# Qty-ordered Unit Qty-to-ship Item/Svc # Unit price Extend-price Shp-date Whse
Type Qty-backord Description-1 Line disc% Scrap/Sls-acct
Description-2
------------------------------------------------------------------------------------------------------------------------------------
10 1 EACH 1 1 55.00 EACH 55.00 5/26/19 Central
Goods Drill, 1/4” Power Hand
20 1 EACH 1 3 23.50 EACH 23.50 5/26/19 Central
Goods Wrench, 3/8” Socket Set
2 lines
Total weight: 3.00
Ordr total: 78.50 Misc amt: 0.00
Ship total: 78.50 Freight: 0.00
Txbl total: 78.50 Tax amt: 0.00
Discnt net: 78.50 Tot sale: 78.50
Amt recd: 0.00
Bal due: 78.50
Tax rate-1 0.00
Date 05/26/2019 Time 17:06:16 XYZ Company Report #0136 Page 0002
B I L L I N G E D I T L I S T
S U M M A R Y
Order # range: “First” to “Last”
Order date range: “Earliest” to “Latest”
Warehouse: All
Order totals: 1 Orders 2 Line items Sale amt: 78.50
Misc chg: 0.00
Tax amt: 0.00
Freight: 0.00
Total: 78.50
Amt recd: 0.00
Bal due: 78.50
Grand totals: 1 Documents 2 Line items Sale amt: 78.50
Misc chg: 0.00
Tax amt: 0.00
Freight: 0.00
Total: 78.50
Amt recd: 0.00
Bal due: 78.50
-- End of report --
Inventory Transaction Register
Date 05/26/2019 Time 17:31:22 XYZ Company Report #0138 Page 0001
I N V E N T O R Y T R A N S A C T I O N R E G I S T E R
Current period ending date: 1/31/19
Inventory valuation method: LIFO
------------------------------------------------------------------------------------------------------------------------------------
Item-# Description Date Type Doc-# Trans-qty Price-1 Price-2 Price-3
Level-# Actual-cost Whs Loc Comment Price-4 Price-5
------------------------------------------------------------------------------------------------------------------------------------
1 Drill, 1/4” Power Hand 5/26/19 CRme 5 1 49.00
12.00 Cen From O/E order: 000003
Sub account: 000
Running-qty-oh: 396
Total actual cost: 12.00
Layer added: 5/26/19 1 EACH at 12.00 cost
1 CR memo Total quantity credited: 1
-----------------------------------------------------------------------------------------
5/26/19 Sale 7 1 55.00
12.00 Cen From O/E order: 000006
Sub account: 100
Running-qty-oh: 395
Total actual cost: 12.00
Layers removed: 5/26/19 1 EACH at 12.00 cost
1 Sale Total quantity sold: 1
-----------------------------------------------------------------------------------------
3 Wrench, 3/8” Socket Set 5/26/19 CRme 5 2 23.50
8.50 Cen From O/E order: 000003
Sub account: 000
Running-qty-oh: 447
Total actual cost: 17.00
Layer added: 5/26/19 2 EACH at 8.50 cost
1 CR memo Total quantity credited: 2
-----------------------------------------------------------------------------------------
5/26/19 Sale 7 1 23.50
8.50 Cen From O/E order: 000006
Sub account: 100
Running-qty-oh: 446
Total actual cost: 8.50
Layers removed: 5/26/19 1 EACH at 8.50 cost
1 Sale Total quantity sold: 1
-----------------------------------------------------------------------------------------
4 Saw, 2hp 7 1/4” Circular 5/26/19 Sale 4 4 56.00
18.00 1 From O/E order: 000002
Sub account: 100
Running-qty-oh: 187
Total actual cost: 72.00
------------------------Serial-Information-------------------------
Date 05/26/2019 Time 17:31:22 XYZ Company Report #0138 Page 0002
I N V E N T O R Y T R A N S A C T I O N R E G I S T E R
------------------------------------------------------------------------------------------------------------------------------------
Item-# Description Date Type Doc-# Trans-qty Price-1 Price-2 Price-3
Level-# Actual-cost Whs Loc Comment Price-4 Price-5
------------------------------------------------------------------------------------------------------------------------------------
Serial-# N/U Customer-# Invc-# Inv-date Warnty-1 Warnty-2
100 N 10 4 5/26/19
102 N 10 4 5/26/19
103 N 10 4 5/26/19
104 N 10 4 5/26/19
-------------------------------------------------------------------
Layers removed: 1/27/19 1 EACH at 18.00 cost
Negative layer added: 5/26/19 3- EACH at 18.00 cost
1 Sale Total quantity sold: 4
-----------------------------------------------------------------------------------------
Date 05/26/2019 Time 17:31:22 XYZ Company Report #0138 Page 0003
I N V E N T O R Y T R A N S A C T I O N R E G I S T E R
Total receiving entries: 0 Total qty received: 0 Total actual cost of receivings: 0.00
Total credit memo entries: 2 Total credit memo qty: 3 Total value of credit memos: 96.00
Total actual cost of credit memos: 29.00
Credit memo margin: 67.00
Total transfer entries: 0 Total qty transferred: 0
Total up adj entries: 0 Total qty adjusted: 0 Total actual cost of upward adj: 0.00
Total down adj entries: 0 Total qty adjusted: 0 Total actual cost of downward adj: 0.00
Total sale entries: 3 Total sale qty: 6 Total value of sales: 302.50
Total actual cost of sales: 92.50
Sales margin: 210.00
Total component usage Total actual cost of
entries for kit assembly: 0 Total comp qty used: 0 inventory used as components: 0.00
Total kit assembly entries: 0 Total kit qty assmbled: 0 Total actual cost of kit assembly: 0.00
-- End of report --
Date 05/26/2019 Time 17:31:22 XYZ Company Report #0139 Page 0001
M I S C E L L A N E O U S C H A R G E S J O U R N A L
Sales entries are printed in document number order
Current period end date: 1/31/19
Document types: CR = credit memo, DR = debit memo, FIN = finance charge, INVC = invoice
------------------------------------------------------------------------------------------------------------------------------------
Cust-# Name Doc-# Tx-Cd Apply-to Sale-amt Freight Total-amt P.O.-#
Doc-type Reference Doc-date Terms Due-date Misc-chgs Sales-Tax Cost Sls-rep Commission
------------------------------------------------------------------------------------------------------------------------------------
10 Harris, Goldberg & Jones 4 DST 224.00 0.00 237.49
INVC From O/E order: 000002 05/26/19 A 06/25/19 0.00 13.49 72.00 1 15.20
Automatic distributions: 2210-000 County sales taxes payable 6.57
2220-000 City sales taxes payable 6.92
Optional distributions: 4010-100 Sales - tools 224.00
1 Elliot Enterprises 5 CTY 1018 96.00- 0.00 102.72-
CR From O/E order: 000003 05/26/19 B 05/26/19 0.00 6.72- 29.00- 1 0.00
Automatic distributions: 2210-000 County sales taxes payable 6.72-
Optional distributions: 4010-000 Equipment income/expense 96.00-
50 Space Concepts & Design 6 OST 0.00 4.00 12.00 948H
INVC From O/E order: 000004 05/26/19 3 06/20/19 8.00 0.00 0.00 789 0.00
Optional distributions: 4030-300 Freight - shipping 4.00
4040-000 Misc. charges on sales 8.00
40 Washington, Mrs. Thomas 7 OST 78.50 0.00 78.50
INVC From O/E order: 000006 05/26/19 2 06/25/19 0.00 0.00 20.50 1 3.65
Optional distributions: 4010-100 Sales - tools 78.50
Date 05/26/2019 Time 17:31:22 XYZ Company Report #0139 Page 0002
M I S C E L L A N E O U S C H A R G E S J O U R N A L
Grand totals
------------------------------------------------------------------------------------------------------------------------------------
Sale-amt Freight Total-amt
Misc-chgs Sales-Tax Cost Commission
------------------------------------------------------------------------------------------------------------------------------------
4 entries Grand totals: 206.50 4.00 225.27
8.00 6.77 63.50 18.85
Acct-# Description Debits Credits
Distribution summary: 1100-000 Accounts receivable 327.99 102.72
2210-000 County sales taxes payable 6.72 6.57
2220-000 City sales taxes payable .00 6.92
4010-000 Equipment income/expense 96.00 .00
4010-100 Sales - tools .00 302.50
4030-300 Freight - shipping .00 4.00
4040-000 Misc. charges on sales .00 8.00
-------------------------------------------
Totals: 430.71 430.71
**** One or more entries are dated beyond the current period ending date ****
**** Please be sure to run Period/Year End Closing at your earliest opportunity ****
-- End of report --
Date 05/27/2019 Time 10:01:13 XYZ Company Report #0140 Page 0001
E . D . I . O R D E R E X P O R T R E P O R T
Order # range: First to Last
E.D.I. document # range: First to Last
Export file name: C:DIORDEXP.TXT
Export file method: Create
------------------------------------------------------------------------------------------------------------------------------------
O/E order # E.D.I. document # Number of order lines Lines of order notes Messages
------------------------------------------------------------------------------------------------------------------------------------
7 789 1 0
Total orders processed: 1 Total orders in error: 0 Total orders exported: 1
-- End of report --
Date 05/27/2019 Time 10:01:42 XYZ Company Report #0141 Page 0001
E . D . I . S T A T U S R E P O R T
Order # range: First to Last
E.D.I. document # range: First to Last
For status types: All
In sequence by: Order #
Show history details: No
Purge closed records: No
------------------------------------------------------------------------------------------------------------------------------------
Ordr # EDI doc # Order Imported Added Deleted Invoiced Process Posted Complete Exported
Status date date date date date date date date
------------------------------------------------------------------------------------------------------------------------------------
7 789 Added 5/27/19
Totals: 1
-- End of report --
Date 05/27/2019 Time 10:30:39 XYZ Company Report #0143 Page 0001
O R D E R S B Y O R D E R N U M B E R
Order range: “First” to “Last” D E T A I L
Order date range: “Earliest” to “Latest”
Ship date range: “Earliest” to “Latest”
Customer # range: “First” to “Last”
Customer name range: “First” to “Last”
Item range: “First” to “Last” Service range: “First” to “Last”
Warehouse: “All”
------------------------------------------------------------------------------------------------------------------------------------
Order-# Type Cust-# Apply-to Slp Shp-date Warehse Ordr-total Discnt-net Misc-chgs Total-sale Amt-rec’d
Ord-date Status Bill-to Ship-via Ship-total Freight Tax amount Balance-due
------------------------------------------------------------------------------------------------------------------------------------
1 Order 1 001 5/25/19 All 49.00 49.00 0.00 49.00 0.00
5/25/19 Elliot Enterprises Truck 49.00 0.00 0.00 49.00
Seq# Item/Svc # Description Whse Qty-ordered Unit Qty-to-ship Unit-price Ext-price
10 1 Drill, 1/4” Power Hand 1 1 EACH 1 49.00 49.00
5 Order 40 001 5/26/19 All 19,875.00 15,052.00 0.00 15,052.00 0.00
5/26/19 Washington, Mrs. Thomas Parcel Post 15,052.00 0.00 0.00 15,052.00
Seq# Item/Svc # Description Whse Qty-ordered Unit Qty-to-ship Unit-price Ext-price
10 2 Hammer, 16 oz. Claw Cen 750 EACH 568 26.50 15,052.00
182 on B/O
7 Order 50 789 5/27/19 All 55.00 55.00 0.00 55.00 0.00
5/27/19 Space Concepts & Design Parcel Post 55.00 0.00 0.00 55.00
Seq# Item/Svc # Description Whse Qty-ordered Unit Qty-to-ship Unit-price Ext-price
10 1 Drill, 1/4” Power Hand Cen 1 EACH 1 55.00 55.00
Date 05/27/2019 Time 10:30:39 XYZ Company Report #0143 Page 0002
O R D E R S B Y O R D E R N U M B E R
Order range: “First” to “Last” D E T A I L
------------------------------------------------------------------------------------------------------------------------------------
Order-# Type Cust-# Apply-to Slp Shp-date Warehse Ordr-total Discnt-net Misc-chgs Total-sale Amt-rec’d
Ord-date Status Bill-to Ship-via Ship-total Freight Tax amount Balance-due
------------------------------------------------------------------------------------------------------------------------------------
Order totals: 3 Orders 3 Line items 19,979.00 0.00 15,156.00
15,156.00 0.00
15,156.00 0.00
0.00 15,156.00
Grand totals: 3 Documents 3 Line items 19,979.00 0.00 15,156.00
15,156.00 0.00
15,156.00 0.00
0.00 15,156.00
-- End of report --
Date 05/27/2019 Time 11:37:43 XYZ Company Report #0144 Page 0001
I N V O I C E H I S T O R Y B Y C U S T O M E R
Customer: 1 Elliot Enterprises
123 Broadway
Suite 500
Glendale, CA 94994
Telephone: 213-779-6010
“CM” next to invoice number and order number indicates a Credit Memo.
“Qty-shipped” is shown in the item’s “stock unit”.
Margins reflect actual costs based on invoice posting.
------------------------------------------------------------------------------------------------------------------------------------
Item/Svc # Invc-# Invc-date Qty-shipped Unit price Lin-disc% Ext-price
Description-1 Ordr-# Ordr-date Unit cost Sales rep Warehouse Ord-disc% Ext-cost
Description-2 Gross-margin Margin-%
------------------------------------------------------------------------------------------------------------------------------------
1 5CM 05/26/19 1 EACH 49.00 per EACH 0.000 49.00-
Drill, 1/4” Power Hand 3CM 05/25/19 12.00 EACH 1 Central 0.000 12.00-
37.00- 75.5
Item 1 totals: 1- 49.00-
12.00-
37.00- 75.5
3 5CM 05/26/19 2 EACH 23.50 per EACH 0.000 47.00-
Wrench, 3/8” Socket Set 3CM 05/25/19 8.50 EACH 1 Central 0.000 17.00-
30.00- 63.8
Item 3 totals: 2- 47.00-
17.00-
30.00- 63.8
Customer 1 totals: 3- 96.00-
29.00-
67.00- 69.8
-- End of report --
Date 05/27/2019 Time 11:43:16 XYZ Company Report #0145 Page 0001
I N V O I C E H I S T O R Y B Y I N V O I C E
Invoice #: 1020 Invoice date: 01/25/19 Customer: 30 W.J. Bjornfreg A/G Sales rep: 20
Order #: 34 Order date: 01/25/19 1 Wilshire Blvd.
Telephone: 213-886-7722
Margins reflect actual costs based on invoice posting.
------------------------------------------------------------------------------------------------------------------------------------
Seq# Item/Svc # Description-1 Qty-shipped Unit price Lin-disc% Ext-price
Description-2 Unit cost Warehouse Ord-disc% Ext-cost
Gross-margin Margin-%
------------------------------------------------------------------------------------------------------------------------------------
10 2 Hammer, 16 oz. Claw 2 EACH 26.50 per EACH 0.000 53.00
9.00 EACH Central 0.000 18.00
35.00 66.0
20 1000 Starter Tool Set 1 EACH 110.00 per EACH 0.000 110.00
Kit Item 34.50 EACH Central 0.000 34.50
75.50 68.6
Invoice totals: 163.00
52.50
110.50 67.8
Date 05/27/2019 Time 11:43:16 XYZ Company Report #0145 Page 0002
I N V O I C E H I S T O R Y B Y I N V O I C E
Invoice #: 1021 Invoice date: 01/25/19 Customer: 40 Washington, Mrs. Thomas Sales rep: 1
Order #: 35 Order date: 01/25/19 350 Hillcrest Circle
Telephone: 617-444-7780
Margins reflect actual costs based on invoice posting.
------------------------------------------------------------------------------------------------------------------------------------
Seq# Item/Svc # Description-1 Qty-shipped Unit price Lin-disc% Ext-price
Description-2 Unit cost Warehouse Ord-disc% Ext-cost
Gross-margin Margin-%
------------------------------------------------------------------------------------------------------------------------------------
10 6 Motor, 2hp Submersible 5 EACH 135.00 per EACH 0.000 675.00
55.00 EACH Central 0.000 275.00
400.00 59.3
20 4 Saw, 2hp 7 1/4” Circular 5 EACH 56.00 per EACH 0.000 280.00
18.00 EACH Central 0.000 90.00
190.00 67.9
Invoice totals: 955.00
365.00
590.00 61.8
Date 05/27/2019 Time 11:43:16 XYZ Company Report #0145 Page 0003
I N V O I C E H I S T O R Y B Y I N V O I C E
Invoice #: 1022 Invoice date: 01/25/19 Customer: 50 Space Concepts & Design Sales rep: 789
Order #: 36 Order date: 01/25/19 3901 Ave. of the Americas
Telephone: 212-220-9981
Margins reflect actual costs based on invoice posting.
------------------------------------------------------------------------------------------------------------------------------------
Seq# Item/Svc # Description-1 Qty-shipped Unit price Lin-disc% Ext-price
Description-2 Unit cost Warehouse Ord-disc% Ext-cost
Gross-margin Margin-%
------------------------------------------------------------------------------------------------------------------------------------
10 3 Wrench, 3/8” Socket Set 10 EACH 23.50 per EACH 0.000 235.00
8.50 EACH Central 0.000 85.00
150.00 63.8
Invoice totals: 235.00
85.00
150.00 63.8
-- End of report --
Date 05/27/2019 Time 11:50:02 XYZ Company Report #0146 Page 0001
I N V O I C E H I S T O R Y B Y I T E M
Item: 1 Drill, 1/4” Power Hand Stocking unit: EACH
“CM” next to invoice number and order number indicates a Credit Memo.
Margins reflect actual costs based on invoice posting.
------------------------------------------------------------------------------------------------------------------------------------
Customer-# Name Invc-# Invc-date Qty-shipped Unit price Lin-disc% Ext-price
Address-1 Ordr-# Ordr-date Unit cost Sales rep Warehse Ord-disc% Ext-cost
Gross-margin Margin-%
------------------------------------------------------------------------------------------------------------------------------------
1 Elliot Enterprises 5CM 05/26/19 1 EACH 49.00 per EACH 0.000 49.00-
123 Broadway 3CM 05/25/19 12.00 EACH 1 Central 0.000 12.00-
Phone: 213-779-6010 37.00- 75.5
1018 01/25/19 5 EACH 49.00 per EACH 0.000 245.00
32 01/25/19 12.00 EACH 1 Central 0.000 60.00
185.00 75.5
Customer 1 totals: 4 196.00
48.00
148.00 75.5
40 Washington, Mrs. Thomas 7 05/26/19 1 EACH 55.00 per EACH 0.000 55.00
350 Hillcrest Circle 6 05/26/19 12.00 EACH 1 Central 0.000 12.00
Phone: 617-444-7780 43.00 78.2
Customer 40 totals: 1 55.00
12.00
43.00 78.2
200 21st Century Enterprises 1025 01/25/19 10 EACH 55.00 per EACH 0.000 522.50
P.O. Box 4545 39 01/25/19 12.00 EACH 10 Central 5.000 120.00
Phone: 415-555-7844 402.50 77.0
Customer 200 totals: 10 522.50
Date 05/27/2019 Time 11:50:02 XYZ Company Report #0146 Page 0002
I N V O I C E H I S T O R Y B Y I T E M
Item: 1 Drill, 1/4” Power Hand Stocking unit: EACH
“CM” next to invoice number and order number indicates a Credit Memo.
Margins reflect actual costs based on invoice posting.
------------------------------------------------------------------------------------------------------------------------------------
Customer-# Name Invc-# Invc-date Qty-shipped Unit price Lin-disc% Ext-price
Address-1 Ordr-# Ordr-date Unit cost Sales rep Warehse Ord-disc% Ext-cost
Gross-margin Margin-%
------------------------------------------------------------------------------------------------------------------------------------
600 Ariel Enterprises 1027 01/25/19 5 EACH 55.00 per EACH 0.000 275.00
555 N. Grand Blvd. 41 01/25/19 12.00 EACH 23 Central 0.000 60.00
Phone: 213-554-4300 215.00 78.2
Customer 600 totals: 5 275.00
60.00
215.00 78.2
Item 1 totals: 24 1,268.50
288.00
980.50 77.3
-- End of report --